<cfquery name="qryMRF" datasource="#session.company_dsn#" >
	    SELECT  REQUISITIONNO, 
	    		A.DATELASTUPDATE AS DATELASTUPDATE,
	    		RANKCODE,
	            SKILLSREQ,
	            SPECTRAINING,
	            SEX,
	            REQUISITIONEDBY,
	            REPLACEMENTREASON,
	            REPORTINGTO,
	            REPLACEMENTOF,
	            RELIGION,
	            NATUREOFJOBVAC,
	    		NATUREOFEMP,
	    		NATIONALITY,
	    		MARITALSTAT,
	    	    EFFECTIVE,
	    		AGE,
	            BRIEFDESC,
	            DATE,
	            DATEREQUISITION,
	            IFCONTRACTUAL,
	            DATETO,
	            DEGREEREQ, 
	            EDUCATTAINMENT,
	    		DATENEEDED,
	            DEPARTMENTCODE,
	            DIVISIONCODE,
	            B.DESCRIPTION AS DESCRIPTION,
	            STATUS,
	            REQUIREDNO,
	            PROJECTCODE, 
	            SOURCENAME,
	            POSTED,
	            POSTEDBYIBOSE, 
	            POSTEDTO
	            
	      FROM  CRGPERSONELREQUEST A LEFT JOIN CLKPOSITION B ON (A.POSITIONCODE = B.POSITIONCODE)
	      
	      limit 50;
	      
</cfquery>

<cfdump var="#qryMRF#" >